Dataset statistics
| Number of variables | 12 |
|---|---|
| Number of observations | 5201393 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 515.9 MiB |
| Average record size in memory | 104.0 B |
Variable types
| Categorical | 1 |
|---|---|
| Numeric | 11 |
DATEUTC has a high cardinality: 52560 distinct values | High cardinality |
LC_HUMIDITY is highly overall correlated with LC_RAD and 2 other fields | High correlation |
LC_DWPTEMP is highly overall correlated with LC_TEMP | High correlation |
LC_RAD is highly overall correlated with LC_HUMIDITY and 1 other fields | High correlation |
LC_RAD60 is highly overall correlated with LC_HUMIDITY and 2 other fields | High correlation |
LC_TEMP is highly overall correlated with LC_HUMIDITY and 2 other fields | High correlation |
LC_RAININ is highly skewed (γ1 = 47.01423082) | Skewed |
DATEUTC is uniformly distributed | Uniform |
LC_RAD has 2599146 (50.0%) zeros | Zeros |
LC_RAININ has 5038773 (96.9%) zeros | Zeros |
LC_DAILYRAIN has 4309199 (82.8%) zeros | Zeros |
LC_WINDDIR has 2009326 (38.6%) zeros | Zeros |
LC_WINDSPEED has 2108572 (40.5%) zeros | Zeros |
LC_RAD60 has 2511732 (48.3%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-24 15:57:20.528655 |
|---|---|
| Analysis finished | 2023-04-24 15:58:54.757752 |
| Duration | 1 minute and 34.23 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
DATEUTC
Categorical
HIGH CARDINALITY  UNIFORM 
| Distinct | 52560 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.4 MiB |
| 2022-09-02 15:40:00 | 108 |
|---|---|
| 2022-09-02 09:30:00 | 108 |
| 2022-09-01 04:00:00 | 108 |
| 2022-09-01 05:10:00 | 108 |
| 2022-09-01 05:20:00 | 108 |
| Other values (52555) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 98826467 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 4 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2022-01-01 00:10:00 |
|---|---|
| 2nd row | 2022-01-01 00:20:00 |
| 3rd row | 2022-01-01 00:30:00 |
| 4th row | 2022-01-01 00:40:00 |
| 5th row | 2022-01-01 00:50:00 |
Common Values
| Value | Count | Frequency (%) |
| 2022-09-02 15:40:00 | 108 | < 0.1% |
| 2022-09-02 09:30:00 | 108 | < 0.1% |
| 2022-09-01 04:00:00 | 108 | < 0.1% |
| 2022-09-01 05:10:00 | 108 | < 0.1% |
| 2022-09-01 05:20:00 | 108 | < 0.1% |
| 2022-09-01 05:30:00 | 108 | < 0.1% |
| 2022-09-01 05:40:00 | 108 | < 0.1% |
| 2022-09-01 05:50:00 | 108 | < 0.1% |
| 2022-09-01 06:10:00 | 108 | < 0.1% |
| 2022-09-01 06:20:00 | 108 | < 0.1% |
| Other values (52550) | 5200313 |
Length
| Value | Count | Frequency (%) |
| 17:20:00 | 36310 | 0.3% |
| 17:10:00 | 36296 | 0.3% |
| 17:00:00 | 36288 | 0.3% |
| 19:00:00 | 36288 | 0.3% |
| 18:50:00 | 36285 | 0.3% |
| 16:50:00 | 36275 | 0.3% |
| 16:40:00 | 36271 | 0.3% |
| 17:30:00 | 36269 | 0.3% |
| 07:20:00 | 36263 | 0.3% |
| 07:10:00 | 36261 | 0.3% |
| Other values (500) | 10039980 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 30843261 | |
| 2 | 21008421 | |
| - | 10402786 | 10.5% |
| : | 10402786 | 10.5% |
| 1 | 8198089 | 8.3% |
| 5201393 | 5.3% | |
| 3 | 2706229 | 2.7% |
| 5 | 2259823 | 2.3% |
| 4 | 2215071 | 2.2% |
| 8 | 1411809 | 1.4% |
| Other values (3) | 4176799 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 72819502 | |
| Dash Punctuation | 10402786 | 10.5% |
| Other Punctuation | 10402786 | 10.5% |
| Space Separator | 5201393 | 5.3% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 30843261 | |
| 2 | 21008421 | |
| 1 | 8198089 | 11.3% |
| 3 | 2706229 | 3.7% |
| 5 | 2259823 | 3.1% |
| 4 | 2215071 | 3.0% |
| 8 | 1411809 | 1.9% |
| 7 | 1407574 | 1.9% |
| 6 | 1384659 | 1.9% |
| 9 | 1384566 | 1.9% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 10402786 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 10402786 |
Space Separator
| Value | Count | Frequency (%) |
| 5201393 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 98826467 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 30843261 | |
| 2 | 21008421 | |
| - | 10402786 | 10.5% |
| : | 10402786 | 10.5% |
| 1 | 8198089 | 8.3% |
| 5201393 | 5.3% | |
| 3 | 2706229 | 2.7% |
| 5 | 2259823 | 2.3% |
| 4 | 2215071 | 2.2% |
| 8 | 1411809 | 1.4% |
| Other values (3) | 4176799 | 4.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 98826467 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 30843261 | |
| 2 | 21008421 | |
| - | 10402786 | 10.5% |
| : | 10402786 | 10.5% |
| 1 | 8198089 | 8.3% |
| 5201393 | 5.3% | |
| 3 | 2706229 | 2.7% |
| 5 | 2259823 | 2.3% |
| 4 | 2215071 | 2.2% |
| 8 | 1411809 | 1.4% |
| Other values (3) | 4176799 | 4.2% |
ID
Real number (ℝ)
| Distinct | 108 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 72.338427 |
| Minimum | 2 |
|---|---|
| Maximum | 138 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.4 MiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 42 |
| median | 74 |
| Q3 | 108 |
| 95-th percentile | 130 |
| Maximum | 138 |
| Range | 136 |
| Interquartile range (IQR) | 66 |
Descriptive statistics
| Standard deviation | 39.500699 |
|---|---|
| Coefficient of variation (CV) | 0.54605416 |
| Kurtosis | -1.1678772 |
| Mean | 72.338427 |
| Median Absolute Deviation (MAD) | 34 |
| Skewness | -0.13783482 |
| Sum | 3.7626059 × 108 |
| Variance | 1560.3052 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 122 | 52544 | 1.0% |
| 123 | 52542 | 1.0% |
| 22 | 52540 | 1.0% |
| 111 | 52539 | 1.0% |
| 124 | 52537 | 1.0% |
| 19 | 52535 | 1.0% |
| 112 | 52533 | 1.0% |
| 117 | 52519 | 1.0% |
| 80 | 52519 | 1.0% |
| 105 | 52500 | 1.0% |
| Other values (98) | 4676085 |
| Value | Count | Frequency (%) |
| 2 | 51359 | |
| 3 | 50285 | |
| 4 | 49875 | |
| 5 | 48084 | |
| 6 | 49191 | |
| 8 | 37594 | |
| 9 | 52403 | |
| 10 | 48086 | |
| 11 | 42811 | |
| 12 | 48512 |
| Value | Count | Frequency (%) |
| 138 | 22670 | |
| 137 | 30406 | |
| 136 | 30142 | |
| 135 | 26823 | |
| 134 | 26229 | |
| 133 | 33364 | |
| 132 | 33909 | |
| 131 | 33865 | |
| 130 | 33866 | |
| 129 | 33911 |
LC_HUMIDITY
Real number (ℝ)
| Distinct | 88 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 76.626124 |
| Minimum | 12 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.4 MiB |
Quantile statistics
| Minimum | 12 |
|---|---|
| 5-th percentile | 41 |
| Q1 | 64 |
| median | 82 |
| Q3 | 92 |
| 95-th percentile | 99 |
| Maximum | 99 |
| Range | 87 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 18.527435 |
|---|---|
| Coefficient of variation (CV) | 0.24179006 |
| Kurtosis | -0.4223342 |
| Mean | 76.626124 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | -0.74815239 |
| Sum | 3.9856258 × 108 |
| Variance | 343.26587 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 99 | 330235 | 6.3% |
| 96 | 159521 | 3.1% |
| 95 | 157470 | 3.0% |
| 94 | 155972 | 3.0% |
| 97 | 152718 | 2.9% |
| 93 | 149949 | 2.9% |
| 92 | 147093 | 2.8% |
| 91 | 140775 | 2.7% |
| 90 | 140261 | 2.7% |
| 98 | 137285 | 2.6% |
| Other values (78) | 3530114 |
| Value | Count | Frequency (%) |
| 12 | 1 | < 0.1% |
| 13 | 40 | < 0.1% |
| 14 | 211 | < 0.1% |
| 15 | 445 | < 0.1% |
| 16 | 648 | |
| 17 | 656 | |
| 18 | 675 | |
| 19 | 706 | |
| 20 | 1070 | |
| 21 | 1480 |
| Value | Count | Frequency (%) |
| 99 | 330235 | |
| 98 | 137285 | |
| 97 | 152718 | |
| 96 | 159521 | |
| 95 | 157470 | |
| 94 | 155972 | |
| 93 | 149949 | |
| 92 | 147093 | |
| 91 | 140775 | |
| 90 | 140261 |
LC_DWPTEMP
Real number (ℝ)
| Distinct | 3505 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.1473083 |
| Minimum | -12.6 |
|---|---|
| Maximum | 25.78 |
| Zeros | 4415 |
| Zeros (%) | 0.1% |
| Negative | 430919 |
| Negative (%) | 8.3% |
| Memory size | 79.4 MiB |
Quantile statistics
| Minimum | -12.6 |
|---|---|
| 5-th percentile | -1.45 |
| Q1 | 4.25 |
| median | 8.76 |
| Q3 | 12.28 |
| 95-th percentile | 16.27 |
| Maximum | 25.78 |
| Range | 38.38 |
| Interquartile range (IQR) | 8.03 |
Descriptive statistics
| Standard deviation | 5.4547058 |
|---|---|
| Coefficient of variation (CV) | 0.66951017 |
| Kurtosis | -0.40094307 |
| Mean | 8.1473083 |
| Median Absolute Deviation (MAD) | 3.96 |
| Skewness | -0.37695549 |
| Sum | 42377352 |
| Variance | 29.753815 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.39 | 9706 | 0.2% |
| 8.89 | 9562 | 0.2% |
| 9.28 | 9312 | 0.2% |
| 9.22 | 9196 | 0.2% |
| 9.11 | 9183 | 0.2% |
| 9.5 | 9112 | 0.2% |
| 9.61 | 9060 | 0.2% |
| 6.61 | 8616 | 0.2% |
| 9.72 | 8572 | 0.2% |
| 9.78 | 8570 | 0.2% |
| Other values (3495) | 5110504 |
| Value | Count | Frequency (%) |
| -12.6 | 3 | |
| -12.5 | 2 | |
| -12.4 | 1 | < 0.1% |
| -12.34 | 1 | < 0.1% |
| -12.33 | 2 | |
| -12.3 | 2 | |
| -12.29 | 1 | < 0.1% |
| -12.28 | 2 | |
| -12.25 | 2 | |
| -12.24 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 25.78 | 1 | |
| 24.27 | 1 | |
| 24.22 | 1 | |
| 24.21 | 1 | |
| 24.17 | 1 | |
| 24.15 | 1 | |
| 23.89 | 1 | |
| 23.83 | 1 | |
| 23.8 | 1 | |
| 23.78 | 1 |
LC_n
Real number (ℝ)
| Distinct | 47 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.386937 |
| Minimum | 1 |
|---|---|
| Maximum | 47 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.4 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 37 |
| median | 37 |
| Q3 | 38 |
| 95-th percentile | 38 |
| Maximum | 47 |
| Range | 46 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 6.6837961 |
|---|---|
| Coefficient of variation (CV) | 0.1888775 |
| Kurtosis | 12.8184 |
| Mean | 35.386937 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -3.6727055 |
| Sum | 1.8406137 × 108 |
| Variance | 44.673131 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 37 | 2136855 | |
| 38 | 2121990 | |
| 35 | 168433 | 3.2% |
| 32 | 152223 | 2.9% |
| 36 | 152160 | 2.9% |
| 31 | 73838 | 1.4% |
| 10 | 19816 | 0.4% |
| 30 | 18849 | 0.4% |
| 3 | 18618 | 0.4% |
| 8 | 18373 | 0.4% |
| Other values (37) | 320238 | 6.2% |
| Value | Count | Frequency (%) |
| 1 | 11236 | |
| 2 | 18098 | |
| 3 | 18618 | |
| 4 | 17262 | |
| 5 | 17194 | |
| 6 | 16255 | |
| 7 | 16289 | |
| 8 | 18373 | |
| 9 | 16256 | |
| 10 | 19816 |
| Value | Count | Frequency (%) |
| 47 | 4 | < 0.1% |
| 46 | 1 | < 0.1% |
| 45 | 7 | < 0.1% |
| 44 | 11 | < 0.1% |
| 43 | 15 | < 0.1% |
| 42 | 22 | < 0.1% |
| 41 | 28 | < 0.1% |
| 40 | 38 | < 0.1% |
| 39 | 3391 | 0.1% |
| 38 | 2121990 |
LC_RAD
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 915 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 79.441832 |
| Minimum | 0 |
|---|---|
| Maximum | 994 |
| Zeros | 2599146 |
| Zeros (%) | 50.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 85 |
| 95-th percentile | 446 |
| Maximum | 994 |
| Range | 994 |
| Interquartile range (IQR) | 85 |
Descriptive statistics
| Standard deviation | 144.18438 |
|---|---|
| Coefficient of variation (CV) | 1.814968 |
| Kurtosis | 4.1875575 |
| Mean | 79.441832 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.2014847 |
| Sum | 4.1320819 × 108 |
| Variance | 20789.136 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2599146 | |
| 1 | 44587 | 0.9% |
| 4 | 37275 | 0.7% |
| 3 | 33305 | 0.6% |
| 2 | 31764 | 0.6% |
| 5 | 27346 | 0.5% |
| 6 | 21887 | 0.4% |
| 7 | 19965 | 0.4% |
| 23 | 19301 | 0.4% |
| 22 | 19278 | 0.4% |
| Other values (905) | 2347539 |
| Value | Count | Frequency (%) |
| 0 | 2599146 | |
| 1 | 44587 | 0.9% |
| 2 | 31764 | 0.6% |
| 3 | 33305 | 0.6% |
| 4 | 37275 | 0.7% |
| 5 | 27346 | 0.5% |
| 6 | 21887 | 0.4% |
| 7 | 19965 | 0.4% |
| 8 | 18610 | 0.4% |
| 9 | 17127 | 0.3% |
| Value | Count | Frequency (%) |
| 994 | 1 | |
| 975 | 1 | |
| 950 | 1 | |
| 949 | 1 | |
| 948 | 2 | |
| 946 | 1 | |
| 932 | 2 | |
| 929 | 2 | |
| 927 | 1 | |
| 926 | 1 |
LC_RAININ
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 109 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.00010329541 |
| Minimum | 0 |
|---|---|
| Maximum | 0.38 |
| Zeros | 5038773 |
| Zeros (%) | 96.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 0.38 |
| Range | 0.38 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.00099938377 |
|---|---|
| Coefficient of variation (CV) | 9.6750069 |
| Kurtosis | 8268.0203 |
| Mean | 0.00010329541 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 47.014231 |
| Sum | 537.28 |
| Variance | 9.9876792 × 10-7 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5038773 | |
| 0.002 | 52394 | 1.0% |
| 0.001 | 45502 | 0.9% |
| 0.003 | 26050 | 0.5% |
| 0.004 | 11383 | 0.2% |
| 0.005 | 6730 | 0.1% |
| 0.006 | 5039 | 0.1% |
| 0.007 | 3241 | 0.1% |
| 0.008 | 2394 | < 0.1% |
| 0.009 | 1670 | < 0.1% |
| Other values (99) | 8217 | 0.2% |
| Value | Count | Frequency (%) |
| 0 | 5038773 | |
| 0.001 | 45502 | 0.9% |
| 0.002 | 52394 | 1.0% |
| 0.003 | 26050 | 0.5% |
| 0.004 | 11383 | 0.2% |
| 0.005 | 6730 | 0.1% |
| 0.006 | 5039 | 0.1% |
| 0.007 | 3241 | 0.1% |
| 0.008 | 2394 | < 0.1% |
| 0.009 | 1670 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.38 | 1 | |
| 0.335 | 1 | |
| 0.167 | 1 | |
| 0.141 | 2 | |
| 0.129 | 1 | |
| 0.123 | 1 | |
| 0.114 | 1 | |
| 0.111 | 1 | |
| 0.11 | 1 | |
| 0.109 | 1 |
LC_DAILYRAIN
Real number (ℝ)
| Distinct | 143 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.001219403 |
| Minimum | 0 |
|---|---|
| Maximum | 0.154 |
| Zeros | 4309199 |
| Zeros (%) | 82.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0.007 |
| Maximum | 0.154 |
| Range | 0.154 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.0051042783 |
|---|---|
| Coefficient of variation (CV) | 4.1858832 |
| Kurtosis | 337.45867 |
| Mean | 0.001219403 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.211986 |
| Sum | 6342.594 |
| Variance | 2.6053657 × 10-5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4309199 | |
| 0.002 | 180517 | 3.5% |
| 0.001 | 117857 | 2.3% |
| 0.003 | 81411 | 1.6% |
| 0.004 | 80393 | 1.5% |
| 0.007 | 72072 | 1.4% |
| 0.005 | 60223 | 1.2% |
| 0.006 | 53801 | 1.0% |
| 0.008 | 36683 | 0.7% |
| 0.009 | 28413 | 0.5% |
| Other values (133) | 180824 | 3.5% |
| Value | Count | Frequency (%) |
| 0 | 4309199 | |
| 0.001 | 117857 | 2.3% |
| 0.002 | 180517 | 3.5% |
| 0.003 | 81411 | 1.6% |
| 0.004 | 80393 | 1.5% |
| 0.005 | 60223 | 1.2% |
| 0.006 | 53801 | 1.0% |
| 0.007 | 72072 | 1.4% |
| 0.008 | 36683 | 0.7% |
| 0.009 | 28413 | 0.5% |
| Value | Count | Frequency (%) |
| 0.154 | 5 | < 0.1% |
| 0.153 | 14 | < 0.1% |
| 0.152 | 92 | < 0.1% |
| 0.151 | 786 | |
| 0.15 | 114 | < 0.1% |
| 0.149 | 15 | < 0.1% |
| 0.148 | 10 | < 0.1% |
| 0.147 | 5 | < 0.1% |
| 0.146 | 13 | < 0.1% |
| 0.145 | 9 | < 0.1% |
LC_WINDDIR
Real number (ℝ)
| Distinct | 360 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -5.7668467 |
| Minimum | -179 |
|---|---|
| Maximum | 180 |
| Zeros | 2009326 |
| Zeros (%) | 38.6% |
| Negative | 1706282 |
| Negative (%) | 32.8% |
| Memory size | 79.4 MiB |
Quantile statistics
| Minimum | -179 |
|---|---|
| 5-th percentile | -158 |
| Q1 | -56 |
| median | 0 |
| Q3 | 28 |
| 95-th percentile | 154 |
| Maximum | 180 |
| Range | 359 |
| Interquartile range (IQR) | 84 |
Descriptive statistics
| Standard deviation | 87.305095 |
|---|---|
| Coefficient of variation (CV) | -15.139139 |
| Kurtosis | -0.34495828 |
| Mean | -5.7668467 |
| Median Absolute Deviation (MAD) | 41 |
| Skewness | 0.026819332 |
| Sum | -29995636 |
| Variance | 7622.1797 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2009326 | |
| -146 | 13718 | 0.3% |
| -144 | 13696 | 0.3% |
| -147 | 13694 | 0.3% |
| -145 | 13617 | 0.3% |
| -143 | 13548 | 0.3% |
| -148 | 13527 | 0.3% |
| -149 | 13376 | 0.3% |
| -142 | 13331 | 0.3% |
| -140 | 13291 | 0.3% |
| Other values (350) | 3070269 |
| Value | Count | Frequency (%) |
| -179 | 10505 | |
| -178 | 10710 | |
| -177 | 10996 | |
| -176 | 10885 | |
| -175 | 11254 | |
| -174 | 11275 | |
| -173 | 11566 | |
| -172 | 11784 | |
| -171 | 11913 | |
| -170 | 12017 |
| Value | Count | Frequency (%) |
| 180 | 10536 | |
| 179 | 10309 | |
| 178 | 10151 | |
| 177 | 10039 | |
| 176 | 9800 | |
| 175 | 9720 | |
| 174 | 9610 | |
| 173 | 9679 | |
| 172 | 9692 | |
| 171 | 9596 |
LC_WINDSPEED
Real number (ℝ)
| Distinct | 891 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.28588148 |
| Minimum | 0 |
|---|---|
| Maximum | 13.7 |
| Zeros | 2108572 |
| Zeros (%) | 40.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.04 |
| Q3 | 0.31 |
| 95-th percentile | 1.4 |
| Maximum | 13.7 |
| Range | 13.7 |
| Interquartile range (IQR) | 0.31 |
Descriptive statistics
| Standard deviation | 0.56425252 |
|---|---|
| Coefficient of variation (CV) | 1.9737288 |
| Kurtosis | 20.121346 |
| Mean | 0.28588148 |
| Median Absolute Deviation (MAD) | 0.04 |
| Skewness | 3.7003953 |
| Sum | 1486982 |
| Variance | 0.3183809 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2108572 | |
| 0.01 | 184266 | 3.5% |
| 0.02 | 152146 | 2.9% |
| 0.03 | 121551 | 2.3% |
| 0.04 | 104820 | 2.0% |
| 0.05 | 92702 | 1.8% |
| 0.06 | 83655 | 1.6% |
| 0.07 | 76216 | 1.5% |
| 0.08 | 69690 | 1.3% |
| 0.09 | 64808 | 1.2% |
| Other values (881) | 2142967 |
| Value | Count | Frequency (%) |
| 0 | 2108572 | |
| 0.01 | 184266 | 3.5% |
| 0.02 | 152146 | 2.9% |
| 0.03 | 121551 | 2.3% |
| 0.04 | 104820 | 2.0% |
| 0.05 | 92702 | 1.8% |
| 0.06 | 83655 | 1.6% |
| 0.07 | 76216 | 1.5% |
| 0.08 | 69690 | 1.3% |
| 0.09 | 64808 | 1.2% |
| Value | Count | Frequency (%) |
| 13.7 | 1 | |
| 12.2 | 1 | |
| 12.15 | 1 | |
| 11.44 | 1 | |
| 11.21 | 1 | |
| 10.71 | 1 | |
| 10.62 | 1 | |
| 10.45 | 1 | |
| 10.42 | 1 | |
| 10.41 | 1 |
LC_RAD60
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 861 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 79.430396 |
| Minimum | 0 |
|---|---|
| Maximum | 894 |
| Zeros | 2511732 |
| Zeros (%) | 48.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 79.4 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 88 |
| 95-th percentile | 434 |
| Maximum | 894 |
| Range | 894 |
| Interquartile range (IQR) | 88 |
Descriptive statistics
| Standard deviation | 141.37496 |
|---|---|
| Coefficient of variation (CV) | 1.7798598 |
| Kurtosis | 3.8537509 |
| Mean | 79.430396 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 2.1309413 |
| Sum | 4.131487 × 108 |
| Variance | 19986.881 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2511732 | |
| 1 | 81754 | 1.6% |
| 2 | 49010 | 0.9% |
| 3 | 41212 | 0.8% |
| 4 | 39387 | 0.8% |
| 5 | 26419 | 0.5% |
| 6 | 22233 | 0.4% |
| 7 | 20495 | 0.4% |
| 8 | 18710 | 0.4% |
| 25 | 18255 | 0.4% |
| Other values (851) | 2372186 |
| Value | Count | Frequency (%) |
| 0 | 2511732 | |
| 1 | 81754 | 1.6% |
| 2 | 49010 | 0.9% |
| 3 | 41212 | 0.8% |
| 4 | 39387 | 0.8% |
| 5 | 26419 | 0.5% |
| 6 | 22233 | 0.4% |
| 7 | 20495 | 0.4% |
| 8 | 18710 | 0.4% |
| 9 | 18201 | 0.3% |
| Value | Count | Frequency (%) |
| 894 | 1 | |
| 878 | 1 | |
| 873 | 1 | |
| 870 | 1 | |
| 869 | 1 | |
| 865 | 1 | |
| 860 | 1 | |
| 859 | 1 | |
| 856 | 1 | |
| 855 | 1 |
LC_TEMP
Real number (ℝ)
| Distinct | 4567782 |
|---|---|
| Distinct (%) | 87.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.606175 |
| Minimum | -11.4 |
|---|---|
| Maximum | 42.161164 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 177244 |
| Negative (%) | 3.4% |
| Memory size | 79.4 MiB |
Quantile statistics
| Minimum | -11.4 |
|---|---|
| 5-th percentile | 1.0325705 |
| Q1 | 7.387517 |
| median | 12.349102 |
| Q3 | 17.66019 |
| 95-th percentile | 25.004656 |
| Maximum | 42.161164 |
| Range | 53.561164 |
| Interquartile range (IQR) | 10.272673 |
Descriptive statistics
| Standard deviation | 7.3911548 |
|---|---|
| Coefficient of variation (CV) | 0.58631224 |
| Kurtosis | -0.18548579 |
| Mean | 12.606175 |
| Median Absolute Deviation (MAD) | 5.1488284 |
| Skewness | 0.1501703 |
| Sum | 65569671 |
| Variance | 54.62917 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10.8 | 1400 | < 0.1% |
| 10.2 | 1360 | < 0.1% |
| 11.9 | 1335 | < 0.1% |
| 10.3 | 1334 | < 0.1% |
| 10.9 | 1333 | < 0.1% |
| 13.3 | 1333 | < 0.1% |
| 13.4 | 1310 | < 0.1% |
| 11.3 | 1288 | < 0.1% |
| 13.6 | 1282 | < 0.1% |
| 10.1 | 1281 | < 0.1% |
| Other values (4567772) | 5188137 |
| Value | Count | Frequency (%) |
| -11.4 | 3 | |
| -11.3 | 2 | |
| -11.2 | 1 | < 0.1% |
| -11.18447 | 1 | < 0.1% |
| -11.17442 | 2 | |
| -11.12442 | 1 | < 0.1% |
| -11.1 | 1 | < 0.1% |
| -11.09022 | 2 | |
| -11.07447 | 1 | < 0.1% |
| -11.05952 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 42.16116354 | 1 | |
| 42.12416033 | 1 | |
| 42.02266235 | 1 | |
| 41.95165925 | 1 | |
| 41.93676939 | 1 | |
| 41.85961032 | 1 | |
| 41.83010052 | 1 | |
| 41.70123848 | 1 | |
| 41.36824861 | 1 | |
| 41.23725765 | 1 |
| ID | LC_HUMIDITY | LC_DWPTEMP | LC_n | LC_RAD | LC_RAININ | LC_DAILYRAIN | LC_WINDDIR | LC_WINDSPEED | LC_RAD60 | LC_TEMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ID | 1.000 | -0.064 | 0.009 | 0.053 | 0.001 | -0.001 | 0.002 | 0.038 | 0.050 | 0.002 | 0.038 |
| LC_HUMIDITY | -0.064 | 1.000 | -0.169 | 0.016 | -0.552 | 0.178 | 0.261 | -0.048 | -0.293 | -0.607 | -0.625 |
| LC_DWPTEMP | 0.009 | -0.169 | 1.000 | -0.005 | 0.225 | 0.043 | 0.079 | -0.027 | -0.007 | 0.241 | 0.840 |
| LC_n | 0.053 | 0.016 | -0.005 | 1.000 | -0.010 | 0.001 | -0.005 | -0.004 | -0.017 | -0.010 | -0.008 |
| LC_RAD | 0.001 | -0.552 | 0.225 | -0.010 | 1.000 | -0.053 | -0.051 | -0.001 | 0.350 | 0.954 | 0.482 |
| LC_RAININ | -0.001 | 0.178 | 0.043 | 0.001 | -0.053 | 1.000 | 0.359 | -0.020 | 0.061 | -0.048 | -0.046 |
| LC_DAILYRAIN | 0.002 | 0.261 | 0.079 | -0.005 | -0.051 | 0.359 | 1.000 | -0.066 | 0.136 | -0.035 | -0.068 |
| LC_WINDDIR | 0.038 | -0.048 | -0.027 | -0.004 | -0.001 | -0.020 | -0.066 | 1.000 | -0.093 | -0.002 | 0.012 |
| LC_WINDSPEED | 0.050 | -0.293 | -0.007 | -0.017 | 0.350 | 0.061 | 0.136 | -0.093 | 1.000 | 0.355 | 0.136 |
| LC_RAD60 | 0.002 | -0.607 | 0.241 | -0.010 | 0.954 | -0.048 | -0.035 | -0.002 | 0.355 | 1.000 | 0.522 |
| LC_TEMP | 0.038 | -0.625 | 0.840 | -0.008 | 0.482 | -0.046 | -0.068 | 0.012 | 0.136 | 0.522 | 1.000 |
| DATEUTC | ID | LC_HUMIDITY | LC_DWPTEMP | LC_n | LC_RAD | LC_RAININ | LC_DAILYRAIN | LC_WINDDIR | LC_WINDSPEED | LC_RAD60 | LC_TEMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2022-01-01 00:10:00 | 2 | 92 | 11.78 | 38 | 0 | 0.0 | 0.0 | -169.0 | 0.43 | 0.0 | 13.048027 |
| 1 | 2022-01-01 00:20:00 | 2 | 92 | 11.73 | 37 | 0 | 0.0 | 0.0 | -170.0 | 0.33 | 0.0 | 12.985849 |
| 2 | 2022-01-01 00:30:00 | 2 | 92 | 11.73 | 38 | 0 | 0.0 | 0.0 | -167.0 | 0.46 | 0.0 | 12.950322 |
| 3 | 2022-01-01 00:40:00 | 2 | 92 | 11.72 | 37 | 0 | 0.0 | 0.0 | -160.0 | 0.52 | 0.0 | 12.949550 |
| 4 | 2022-01-01 00:50:00 | 2 | 92 | 11.72 | 38 | 0 | 0.0 | 0.0 | -166.0 | 0.51 | 0.0 | 12.952268 |
| 5 | 2022-01-01 01:00:00 | 2 | 92 | 11.72 | 37 | 0 | 0.0 | 0.0 | -158.0 | 0.93 | 0.0 | 12.938731 |
| 6 | 2022-01-01 01:10:00 | 2 | 92 | 11.71 | 38 | 0 | 0.0 | 0.0 | -161.0 | 0.54 | 0.0 | 12.949960 |
| 7 | 2022-01-01 01:20:00 | 2 | 91 | 11.62 | 37 | 0 | 0.0 | 0.0 | -163.0 | 0.71 | 0.0 | 12.960576 |
| 8 | 2022-01-01 01:30:00 | 2 | 91 | 11.61 | 38 | 0 | 0.0 | 0.0 | -160.0 | 0.54 | 0.0 | 12.980432 |
| 9 | 2022-01-01 01:40:00 | 2 | 91 | 11.61 | 37 | 0 | 0.0 | 0.0 | -163.0 | 0.85 | 0.0 | 12.963181 |
| DATEUTC | ID | LC_HUMIDITY | LC_DWPTEMP | LC_n | LC_RAD | LC_RAININ | LC_DAILYRAIN | LC_WINDDIR | LC_WINDSPEED | LC_RAD60 | LC_TEMP | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5546870 | 2022-12-31 22:30:00 | 138 | 53 | 6.49 | 32 | 0 | 0.0 | 0.002 | -70.0 | 1.45 | 0.0 | 16.39359 |
| 5546871 | 2022-12-31 22:40:00 | 138 | 52 | 6.32 | 31 | 0 | 0.0 | 0.002 | -52.0 | 1.23 | 0.0 | 16.48690 |
| 5546872 | 2022-12-31 22:50:00 | 138 | 51 | 6.30 | 32 | 0 | 0.0 | 0.002 | -64.0 | 1.04 | 0.0 | 16.63222 |
| 5546873 | 2022-12-31 23:00:00 | 138 | 50 | 6.21 | 31 | 0 | 0.0 | 0.002 | -61.0 | 1.43 | 0.0 | 16.71759 |
| 5546874 | 2022-12-31 23:10:00 | 138 | 50 | 6.16 | 32 | 0 | 0.0 | 0.002 | -62.0 | 1.37 | 0.0 | 16.77703 |
| 5546875 | 2022-12-31 23:20:00 | 138 | 50 | 6.05 | 32 | 0 | 0.0 | 0.000 | -49.0 | 0.67 | 0.0 | 16.76285 |
| 5546876 | 2022-12-31 23:30:00 | 138 | 50 | 6.00 | 32 | 0 | 0.0 | 0.000 | -65.0 | 1.39 | 0.0 | 16.70722 |
| 5546877 | 2022-12-31 23:40:00 | 138 | 50 | 5.90 | 31 | 0 | 0.0 | 0.000 | -41.0 | 1.25 | 0.0 | 16.60001 |
| 5546878 | 2022-12-31 23:50:00 | 138 | 50 | 5.89 | 32 | 0 | 0.0 | 0.000 | -51.0 | 1.22 | 0.0 | 16.50053 |
| 5546879 | 2023-01-01 00:00:00 | 138 | 50 | 5.78 | 31 | 0 | 0.0 | 0.000 | -53.0 | 1.08 | 0.0 | 16.37461 |